GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE Get_LookUpByCode
	@Code varchar(250)
AS
BEGIN
	select * from tblLookup where LookUpCode=@Code
END
GO


GO
/****** Object:  StoredProcedure [dbo].[SP_LogoInformationById]    Script Date: 12/04/2011 22:48:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[SP_LogoInformationById]
	@Id int
AS
BEGIN
	select * from LogoInformation li
	where li.Id=@Id

	Select tl.Description as MenuName , d.* from LogoDetail d inner join tblLookup tl on tl.LookUpID=d.MenuId where d.LogoInformationId in (select li.Id from LogoInformation li
	where li.Id=@Id)

	Select * from LogoDetailDetail ddl where ddl.LogoDetailId in (select li.Id from LogoInformation li
	where li.Id=@Id)
	
END
